UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PvCQoMoXC6KvVMr1U4tWpWqJLSABsEz+M4jwkfR38oc='
WHERE
key_id = 'c2882408be79949da42c320e6c43a34acb2350d8c843d67211ae9b7420df14eb'
AND (
token = 'PvCQoMoXC6KvVMr1U4tWpWqJLSABsEz+M4jwkfR38oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)