UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z3JjRYokGuzdpcXR4+rAEtp6yI+yrRBopJVBInEiKDs='
WHERE
key_id = 'c793bc3bfa25bd2f58e23e9beff809dfd6ba9f6531028d6a0cdb903574497f39'
AND (
token = 'Z3JjRYokGuzdpcXR4+rAEtp6yI+yrRBopJVBInEiKDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)