UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mqVQY4kJaoFZgoUY9vigBNcXy5h+Z83dVzpBrosxoo0='
WHERE
key_id = '7aa1c9dcf7f21394ce130d173ce25ec28b54af78379278375a32b892f90ffa2e'
AND (
token = 'mqVQY4kJaoFZgoUY9vigBNcXy5h+Z83dVzpBrosxoo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)