UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mgPuTnak3WkJait3o6gbzJvFkx6jtUGoJWUq9ZHCQa8='
WHERE
key_id = '2304ed9b2770ee22ea03548bbf0b19e526cb35f13ada3a8d617e746ecb34a227'
AND (
token = 'mgPuTnak3WkJait3o6gbzJvFkx6jtUGoJWUq9ZHCQa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)