UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nyQK64uHLhgLAmwcS5eK80GTIq68kPpVXYRoOwY3sYU='
WHERE
key_id = '42b8623abf329da2ea95338187b2ff1fe5de90c3314c0fde34ab05238fb8ad03'
AND (
token = 'nyQK64uHLhgLAmwcS5eK80GTIq68kPpVXYRoOwY3sYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)