UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6X95BnDiuWuxY4WlHXkaD2DmvwV77vNJzHtGN72fCIE='
WHERE
key_id = '562676705a5b2ef568e15a4e0bde31d5adbac1f8a55d0b41c209ee665b40f452'
AND (
token = '6X95BnDiuWuxY4WlHXkaD2DmvwV77vNJzHtGN72fCIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)