UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWYI7+io4YJ7TJ5JNve0s1TZKoL9/DIcLSKu5l9MYGw='
WHERE
key_id = '3b46770fc16e0398ed6d86a13a2aff71a17b197aa2db4b836a79b6acbbec4841'
AND (
token = 'XWYI7+io4YJ7TJ5JNve0s1TZKoL9/DIcLSKu5l9MYGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)