UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WfNW0gd8qqF4+OAX2gLF8/O7Za8/TWOLK70Xg9riM8U='
WHERE
key_id = '3bd4949c5aaa00ffef439330d73ed9514cf32324b3b7842764f03420327f771b'
AND (
token = 'WfNW0gd8qqF4+OAX2gLF8/O7Za8/TWOLK70Xg9riM8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)