UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'axFcOBLRV1VKQN9ml25Ciq4xjpiQe4nzFqfdPwk6FMk='
WHERE
key_id = 'e7aced7464aa72d857b9de6ff833b8a9d2a455029e25e835a9e11effbd03a1ef'
AND (
token = 'axFcOBLRV1VKQN9ml25Ciq4xjpiQe4nzFqfdPwk6FMk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)