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