UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1QUCrzTN2w9Tnb5JmeUzk911HjPMsOzFfs1ZDSbMcsA='
WHERE
key_id = 'dfa0aeef762c710206593a1ab02513677f8e920a16c70ad0c292b70af5573bcc'
AND (
token = '1QUCrzTN2w9Tnb5JmeUzk911HjPMsOzFfs1ZDSbMcsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)