UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9ylAaO8lqgDYSgTfnepgqkkVq8ClKXzadG1+esAt/X4='
WHERE
key_id = 'bfc4818be1263146f0c56733c4623b1298c5b7c65093a71a60a65725225351ee'
AND (
token = '9ylAaO8lqgDYSgTfnepgqkkVq8ClKXzadG1+esAt/X4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)