UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aL+QZLExvRcv4zwU9wXP2hWaFkLXJ67XxacLkz3U//s='
WHERE
key_id = 'a4e65ff5b0ad41e96102f3039c25b8a976ac749ab1f276b60dc2a130b2f24a70'
AND (
token = 'aL+QZLExvRcv4zwU9wXP2hWaFkLXJ67XxacLkz3U//s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)