UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cYHvlUJupB2eTBtfQ1kFZvc+MhkrRoO2l8y9iuVt4w='
WHERE
key_id = 'a6fffe51f29ffa48f149745311d627e67698da67332b604e64f0e793b4e9a0d3'
AND (
token = '0cYHvlUJupB2eTBtfQ1kFZvc+MhkrRoO2l8y9iuVt4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)