UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c+yZCadkMZ6uz5klrDU4K2lJ9dtqXY4PvPhU38FP+xI='
WHERE
key_id = '199abcd672832ac05dda8d990c3f117bc4bc053a570ed929de75d5bcab738448'
AND (
token = 'c+yZCadkMZ6uz5klrDU4K2lJ9dtqXY4PvPhU38FP+xI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)