UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gbVCTAIdHuh5lBkbqt4XQBXPFMxIdikJRe2gBCVseM8='
WHERE
key_id = '145f6bcd6f995873770a5c759380a076de8abaff002ede4e50446655c2f9dd18'
AND (
token = 'gbVCTAIdHuh5lBkbqt4XQBXPFMxIdikJRe2gBCVseM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)