UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pwFxohK77qEKJ5yYHCnmd0Uj+rfbV8jJeLWGI7y9YE='
WHERE
key_id = 'd3aa3f61481f49be3aa53843c6942830264dfc4238578b0a32e061eee4d7572b'
AND (
token = '8pwFxohK77qEKJ5yYHCnmd0Uj+rfbV8jJeLWGI7y9YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)