UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rj7WrO1eF8KoAGGIqW19ZycOUN8tDKbM2CjtJytPHU0='
WHERE
key_id = '0c70ab490a940bd14feaf49e9b4efd76f13eec93e64a51b2c38697129e665c20'
AND (
token = 'rj7WrO1eF8KoAGGIqW19ZycOUN8tDKbM2CjtJytPHU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)