UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O67EZThqDR4IQTuQspfqH1QiwAGVJRXXk35+2jWQKIg='
WHERE
key_id = '26d97ab71fe894308208d1085fea6f51021bae066a9367e82d8b7e5300ea50a1'
AND (
token = 'O67EZThqDR4IQTuQspfqH1QiwAGVJRXXk35+2jWQKIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)