UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XriBkPv+64zy6GHLORrJBEKOthF/ugxvcci2lX+nnjA='
WHERE
key_id = '16f0821eb13b4ffda48432cbd4d42e175e941b4fa237f88560ff96ed23ec9d1b'
AND (
token = 'XriBkPv+64zy6GHLORrJBEKOthF/ugxvcci2lX+nnjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)