UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HMYmb7Bwt/W2cddJxZOM8bDc0poiXOhWGCkXfpPmBR4='
WHERE
key_id = 'f780a3c5d20452f2007cf7abdb637e9d6e028cf8eb60dd57f438d3a38283a2bf'
AND (
token = 'HMYmb7Bwt/W2cddJxZOM8bDc0poiXOhWGCkXfpPmBR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)