UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A9y08wQVoEZKqE32XxnlLwy8u9akK545wksjeShtoxI='
WHERE
key_id = '64428d37565c913ad98682779eb7148095585ddaf9768ec60238f0e6d4574a48'
AND (
token = 'A9y08wQVoEZKqE32XxnlLwy8u9akK545wksjeShtoxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)