UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hIiagvKS1ewcC4un81wzCUlN9dIeDBbnJIHnM+7azRw='
WHERE
key_id = '6a808ccbf6f6a3b7e96b6f729802c96ac7cb8fd54e3f820e70429037034db937'
AND (
token = 'hIiagvKS1ewcC4un81wzCUlN9dIeDBbnJIHnM+7azRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)