UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8zPmuhW1c6wrVyOmPrDAZrzYSJMynfYjStFaaP540kE='
WHERE
key_id = '7e0b70a2c66506c60df31e1954fa8ddf9c2e2cef6cf9246659af7296dd4c4049'
AND (
token = '8zPmuhW1c6wrVyOmPrDAZrzYSJMynfYjStFaaP540kE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)