UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MwaUIOeKWTliyB7JSaF/L14/78rDWfx7q2QJSWeqZ9o='
WHERE
key_id = 'c5fc1ff85b378f7d51d3c7899d87d83c4a795e35b5c74f8b216aedf7ce96e7a6'
AND (
token = 'MwaUIOeKWTliyB7JSaF/L14/78rDWfx7q2QJSWeqZ9o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)