UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4P8//VwgF+n6SnNbWfeYIFS+ULzdR9KzbFFXEWiUepY='
WHERE
key_id = 'd7e678229c76d27e25f84158bba1651257d60f5dffe993e26869cd68908fe247'
AND (
token = '4P8//VwgF+n6SnNbWfeYIFS+ULzdR9KzbFFXEWiUepY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)