UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcIm4NU5lTdiT5vnN3AmUG43lOJj+XVYycTFVpmFikM='
WHERE
key_id = '17271ca000032d6dd44e001c54b978f2f0946df374b118d37feb914c5f56e398'
AND (
token = 'bcIm4NU5lTdiT5vnN3AmUG43lOJj+XVYycTFVpmFikM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)