UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zOXa0DCbCo+NR+S1atRRmPIs4KZHIyGhAeUc6We72kY='
WHERE
key_id = 'bbb32b3b5c8cf8f2db43962e5268f7ab162e97ffb5b67d19b2ef2da680cf400f'
AND (
token = 'zOXa0DCbCo+NR+S1atRRmPIs4KZHIyGhAeUc6We72kY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)