UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGgLWYTWe18iR4F8z2HUyQdRppQ1Xgxnopto1v7h+I0='
WHERE
key_id = 'ae313c1b04b1b567e5d9a15f54b6f0daa44078fffc23c2688e143adf14ce8271'
AND (
token = 'HGgLWYTWe18iR4F8z2HUyQdRppQ1Xgxnopto1v7h+I0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)