UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HdSsKhK+fgk0VafiUL9UsdXDAe+sh+1GmAM5ptJPi1Y='
WHERE
key_id = '1e58f4867fc2444f3fc21a97d886d12235d448efb3153873a0f8c4ef523ceb09'
AND (
token = 'HdSsKhK+fgk0VafiUL9UsdXDAe+sh+1GmAM5ptJPi1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)