UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nc4IfJ8jsMSHPnnT4t2VsYi9EGwhKnmaMvb60yE26Zc='
WHERE
key_id = '3d32a85a2b3887ec03aa365b5ff4fe9f2f2e0796355cdeb88890fae4f31fecbf'
AND (
token = 'nc4IfJ8jsMSHPnnT4t2VsYi9EGwhKnmaMvb60yE26Zc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)