UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZc6ya8+aKpkocdb5y5IPPMrk6p9GqUysqJJMIGnyWs='
WHERE
key_id = 'bc3ecbb99c392ef6e8720ec565d650abf0a9c91dd3cfa416939b37c35b28e158'
AND (
token = 'kZc6ya8+aKpkocdb5y5IPPMrk6p9GqUysqJJMIGnyWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)