UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31epSD5vO+sb9IeScHlQ5qQxgZlzlNlR4F2wpPEa7xo='
WHERE
key_id = 'fb9c27bd431bea571d296133aaac2fbe6a6231d8c518fc96b6a9136ee22d9b92'
AND (
token = '31epSD5vO+sb9IeScHlQ5qQxgZlzlNlR4F2wpPEa7xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)