UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C03t0yDka8a8LXvqc60U7dPCC2gbkmurLPblCXPhysU='
WHERE
key_id = '49ae7fa562f1161a0b9967b2f92bc299f8684a1666a4070b428f5984137a72fe'
AND (
token = 'C03t0yDka8a8LXvqc60U7dPCC2gbkmurLPblCXPhysU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)