UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfiB70YUZAXfmwirNj0kZl/34QXtf3+r8J5aG5Ovu5I='
WHERE
key_id = 'dc8d9d06207c0070e02ec37d1423895e68a6bbf91f8ec1ad58ff98a27105549b'
AND (
token = 'xfiB70YUZAXfmwirNj0kZl/34QXtf3+r8J5aG5Ovu5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)