UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YXf4ODVfgU2sl0THr+fQOUFXukcJEGcgmEMl1n1b20g='
WHERE
key_id = '54306743262b0b07ccd050aa87144361bd8c0ee791456311078fca754ae4902b'
AND (
token = 'YXf4ODVfgU2sl0THr+fQOUFXukcJEGcgmEMl1n1b20g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)