UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6jozHceS5Q7dsaLCOnaHef6pwyUBi4S5OPezTqhJIAI='
WHERE
key_id = '10182674dcce79acfb308e54af5ba37c92745283c304b1e3acd22786f3c42394'
AND (
token = '6jozHceS5Q7dsaLCOnaHef6pwyUBi4S5OPezTqhJIAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)