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