UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4Ve41Vyp8eYRafccXDILV5Sul0L0QhcZa5bnZFwUd0='
WHERE
key_id = 'a419c5f229c9194479be1d72a95279b8364cc59459b1d593b4197fc8af91b1e6'
AND (
token = 'E4Ve41Vyp8eYRafccXDILV5Sul0L0QhcZa5bnZFwUd0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)