UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Ek1SfGfit9QxsIJwqK48i155RkX2hL4HQi5oejz2GE='
WHERE
key_id = '0a80b63d5e0d1714ff80c731d8299b78cdf24efac0e1830aad10ad83e3fcefd0'
AND (
token = '/Ek1SfGfit9QxsIJwqK48i155RkX2hL4HQi5oejz2GE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)