UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpcm32QmIcwnOHjzszDIs4/mMkIBqYIkCFh54hrzvvU='
WHERE
key_id = 'a9d2f2a5b6a7938cc20ccfd01a5fdc63555c7e2bda292ac5b5a14291ad86a01d'
AND (
token = 'cpcm32QmIcwnOHjzszDIs4/mMkIBqYIkCFh54hrzvvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)