UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l1YUkFsr33hnNlZwH2gy/+LoXOsQj38cbARC0MA+9/w='
WHERE
key_id = 'a4ca03b8863b0b42380626734bc95e597fdb6edf3864d38e625cd5e6fc228856'
AND (
token = 'l1YUkFsr33hnNlZwH2gy/+LoXOsQj38cbARC0MA+9/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)