UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xbtSl1LFEcvvm/MD2+VXLnJc4XOsOWM/foZ9C8q+HXo='
WHERE
key_id = 'ef96a812e8b3470e0d67481728d10aec28acd11810c9c9a57741eb49fab7cb5c'
AND (
token = 'xbtSl1LFEcvvm/MD2+VXLnJc4XOsOWM/foZ9C8q+HXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)