UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I0897XhWdOyCdm9WLvm6/x193MleZYGOHgf3f1yPXAk='
WHERE
key_id = '3e18ca146af3bf343ab1a2cc54c8f716b621ac8561c485a3f3a5013af375b197'
AND (
token = 'I0897XhWdOyCdm9WLvm6/x193MleZYGOHgf3f1yPXAk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)