UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sFxJ1hIm+Z8v2lpMVl24Ocfzh4ZVz9tUTHdpiAwpGFM='
WHERE
key_id = 'd485dc2d5e8f16e4df6193aac0b9123b55a928d8b0d7179297dc8f1b0a9ef1c0'
AND (
token = 'sFxJ1hIm+Z8v2lpMVl24Ocfzh4ZVz9tUTHdpiAwpGFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)